explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TiiF

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 17.750 ↓ 10.0 40 1

Limit (cost=1,362.62..1,362.63 rows=4 width=44) (actual time=17.724..17.750 rows=40 loops=1)

2. 2.691 17.732 ↓ 10.0 40 1

Sort (cost=1,362.62..1,362.63 rows=4 width=44) (actual time=17.723..17.732 rows=40 loops=1)

  • Sort Key: lists_entries.created_at DESC, lists_entries.id
  • Sort Method: top-N heapsort Memory: 29kB
3. 4.196 15.041 ↓ 1,821.0 7,284 1

Hash Semi Join (cost=689.33..1,362.58 rows=4 width=44) (actual time=8.501..15.041 rows=7,284 loops=1)

  • Hash Cond: (lists_entries.company_id = lists_entries_1.company_id)
4. 2.369 2.369 ↓ 18.4 7,287 1

Index Scan using lists_entries_organization_id_list_id_index on lists_entries (cost=0.43..670.63 rows=395 width=44) (actual time=0.010..2.369 rows=7,287 loops=1)

  • Index Cond: ((organization_id = 7) AND (list_id = 588))
5. 2.200 8.476 ↓ 18.5 7,284 1

Hash (cost=683.98..683.98 rows=394 width=4) (actual time=8.475..8.476 rows=7,284 loops=1)

  • Buckets: 8192 (originally 1024) Batches: 1 (originally 1) Memory Usage: 321kB
6. 3.672 6.276 ↓ 18.5 7,284 1

Hash Anti Join (cost=7.51..683.98 rows=394 width=4) (actual time=0.059..6.276 rows=7,284 loops=1)

  • Hash Cond: ((lists_entries_1.organization_id = entity_values.organization_id) AND (lists_entries_1.company_id = entity_values.company_id))
7. 2.563 2.563 ↓ 18.4 7,287 1

Index Scan using lists_entries_organization_id_list_id_index on lists_entries lists_entries_1 (cost=0.43..670.63 rows=395 width=8) (actual time=0.008..2.563 rows=7,287 loops=1)

  • Index Cond: ((organization_id = 7) AND (list_id = 588))
8. 0.006 0.041 ↑ 33.7 3 1

Hash (cost=5.56..5.56 rows=101 width=8) (actual time=0.041..0.041 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
9. 0.035 0.035 ↑ 33.7 3 1

Index Only Scan using entity_values_org_id_entity_attribute_id_company_id_index on entity_values (cost=0.56..5.56 rows=101 width=8) (actual time=0.030..0.035 rows=3 loops=1)

  • Index Cond: ((organization_id = 7) AND (entity_attribute_id = 209501))
  • Heap Fetches: 2
Planning time : 2.364 ms
Execution time : 17.825 ms