explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IhQH

Settings
# exclusive inclusive rows x rows loops node
1. 0.520 164.652 ↓ 609.0 609 1

Nested Loop (cost=2.39..13.50 rows=1 width=120) (actual time=8.718..164.652 rows=609 loops=1)

2. 15.279 116.308 ↓ 23,912.0 23,912 1

Nested Loop (cost=1.96..11.05 rows=1 width=188) (actual time=0.439..116.308 rows=23,912 loops=1)

3. 16.737 77.117 ↓ 23,912.0 23,912 1

Nested Loop (cost=1.96..10.01 rows=1 width=158) (actual time=0.430..77.117 rows=23,912 loops=1)

4. 3.477 36.468 ↓ 23,912.0 23,912 1

Nested Loop (cost=1.68..7.75 rows=1 width=91) (actual time=0.422..36.468 rows=23,912 loops=1)

5. 0.493 15.399 ↓ 1,466.0 1,466 1

Nested Loop (cost=1.11..5.15 rows=1 width=96) (actual time=0.148..15.399 rows=1,466 loops=1)

6. 9.042 9.042 ↓ 1,466.0 1,466 1

Index Scan using collections_2_tsrange_idx on collections collections_1 (cost=0.55..2.57 rows=1 width=8) (actual time=0.135..9.042 rows=1,466 loops=1)

  • Index Cond: (tsrange(data_start, data_end, '[]'::text) && '["2019-09-30 22:17:18","2019-09-30 22:17:48"]'::tsrange)
  • Filter: (metadata @> '{}'::jsonb)
7. 5.864 5.864 ↑ 1.0 1 1,466

Index Scan using collections_2_pkey on collections (cost=0.57..2.58 rows=1 width=88) (actual time=0.004..0.004 rows=1 loops=1,466)

  • Index Cond: (id = collections_1.id)
8. 1.466 17.592 ↓ 16.0 16 1,466

Append (cost=0.56..2.59 rows=1 width=19) (actual time=0.006..0.012 rows=16 loops=1,466)

9. 16.126 16.126 ↓ 16.0 16 1,466

Index Scan using files_delete_road_20190930_collection_id_collection_time_idx on files_delete_road_20190930 (cost=0.56..2.58 rows=1 width=19) (actual time=0.006..0.011 rows=16 loops=1,466)

  • Index Cond: ((collection_id = collections.id) AND (collection_time >= '2019-09-30 22:17:18'::timestamp without time zone) AND (collection_time <= '2019-09-30 22:17:48'::timestamp without time zone))
  • Filter: (catalog_id = 1)
10. 23.912 23.912 ↑ 1.0 1 23,912

Index Scan using datasets_pkey on datasets (cost=0.28..2.26 rows=1 width=75) (actual time=0.001..0.001 rows=1 loops=23,912)

  • Index Cond: (id = files_delete_road_20190930.dataset_id)
11. 23.912 23.912 ↑ 1.0 1 23,912

Seq Scan on catalogs (cost=0.00..1.02 rows=1 width=34) (actual time=0.000..0.001 rows=1 loops=23,912)

  • Filter: (id = 1)
  • Rows Removed by Filter: 1
12. 47.824 47.824 ↓ 0.0 0 23,912

Index Scan using partitions_pkey on partitions (cost=0.43..2.44 rows=1 width=149) (actual time=0.002..0.002 rows=0 loops=23,912)

  • Index Cond: (id = files_delete_road_20190930.partition_id)
  • Filter: (metadata @> '{"vin": "5G21A6P05L4100051"}'::jsonb)
  • Rows Removed by Filter: 1
Planning time : 55.263 ms
Execution time : 164.809 ms