explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DpNY

Settings
# exclusive inclusive rows x rows loops node
1. 0.158 2,957.879 ↓ 0.0 0 1

Update on indexing_status status (cost=0.95..76,055.97 rows=1 width=155) (actual time=2,957.879..2,957.879 rows=0 loops=1)

2. 2.468 2,957.721 ↑ 1.0 1 1

Nested Loop (cost=0.95..76,055.97 rows=1 width=155) (actual time=0.844..2,957.721 rows=1 loops=1)

3. 237.169 2,001.341 ↓ 71.5 5,074 1

Hash Join (cost=0.52..76,022.27 rows=71 width=131) (actual time=0.492..2,001.341 rows=5,074 loops=1)

  • Hash Cond: (c.main_structure_id = status.main_structure_id)
4. 1,763.793 1,763.793 ↓ 1.0 3,787,385 1

Seq Scan on catalog c (cost=0.00..62,089.52 rows=3,715,072 width=82) (actual time=0.022..1,763.793 rows=3,787,385 loops=1)

5. 0.006 0.379 ↑ 1.0 1 1

Hash (cost=0.51..0.51 rows=1 width=53) (actual time=0.379..0.379 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.373 0.373 ↑ 1.0 1 1

Index Scan using indexing_status_catalog_structure_id_main_structure_id_idx on indexing_status status (cost=0.29..0.51 rows=1 width=53) (actual time=0.373..0.373 rows=1 loops=1)

  • Index Cond: (catalog_structure_id = 11330)
7. 953.912 953.912 ↓ 0.0 0 5,074

Index Scan using indexing_log_pkey on indexing_log il (cost=0.43..0.46 rows=1 width=14) (actual time=0.188..0.188 rows=0 loops=5,074)

  • Index Cond: (id = c.statistics_indexing_log_id)
  • Filter: ((message ~~ 'catalog committed%'::text) AND (operation_id = 'f58ca3ec-3cf8-4448-a699-4988cf7c8e78'::text))
  • Rows Removed by Filter: 1
Planning time : 2.916 ms
Execution time : 2,958.033 ms