explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eZxn

Settings
# exclusive inclusive rows x rows loops node
1. 366.100 2,982.907 ↑ 1.3 675,656 1

Gather Merge (cost=215,923.06..321,479.12 rows=892,023 width=213) (actual time=2,664.075..2,982.907 rows=675,656 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
2. 251.523 2,616.807 ↑ 1.8 168,914 4 / 4

Sort (cost=214,923.02..215,666.37 rows=297,341 width=213) (actual time=2,587.766..2,616.807 rows=168,914 loops=4)

  • Sort Key: dates_tbl.date DESC
  • Sort Method: external merge Disk: 40376kB
  • Worker 0: Sort Method: external merge Disk: 35304kB
  • Worker 1: Sort Method: external merge Disk: 33224kB
  • Worker 2: Sort Method: external merge Disk: 33664kB
3. 47.161 2,365.284 ↑ 1.8 168,914 4 / 4

Hash Join (cost=24,490.03..170,032.51 rows=297,341 width=213) (actual time=1,443.972..2,365.284 rows=168,914 loops=4)

  • Hash Cond: (data_tbl.author_id = people_tbl.id)
4. 53.286 2,317.789 ↑ 1.8 168,914 4 / 4

Hash Join (cost=24,473.92..169,227.71 rows=297,341 width=207) (actual time=1,443.567..2,317.789 rows=168,914 loops=4)

  • Hash Cond: (data_tbl.date_id = dates_tbl.id)
5. 81.449 2,261.143 ↑ 1.8 168,914 4 / 4

Parallel Hash Join (cost=24,210.70..168,183.61 rows=297,341 width=211) (actual time=1,440.123..2,261.143 rows=168,914 loops=4)

  • Hash Cond: (data_tbl.path_id = paths_tbl.id)
6. 24.809 2,097.331 ↑ 1.8 168,914 4 / 4

Nested Loop (cost=9,909.96..153,102.35 rows=297,341 width=65) (actual time=1,355.849..2,097.331 rows=168,914 loops=4)

7. 1,278.357 1,617.003 ↑ 1.2 91,104 4 / 4

Parallel Bitmap Heap Scan on files_tbl (cost=9,909.96..38,002.97 rows=112,160 width=41) (actual time=1,355.816..1,617.003 rows=91,104 loops=4)

  • Recheck Cond: (filename ~ '[.]((doc|ppt|xls)x|rtf|pdf|odt)\Z'::text)
  • Rows Removed by Index Recheck: 712
  • Heap Blocks: exact=2502
8. 338.646 338.646 ↓ 1.1 367,261 1 / 4

Bitmap Index Scan on ix_testing_files_filename_gist_trgm (cost=0.00..9,823.04 rows=347,697 width=0) (actual time=1,354.582..1,354.582 rows=367,261 loops=1)

  • Index Cond: (filename ~ '[.]((doc|ppt|xls)x|rtf|pdf|odt)\Z'::text)
9. 455.519 455.519 ↑ 10.5 2 364,415 / 4

Index Scan using ix_testing_data_filename_id_hash on data_tbl (cost=0.00..0.82 rows=21 width=40) (actual time=0.003..0.005 rows=2 loops=364,415)

  • Index Cond: (filename_id = files_tbl.id)
  • Rows Removed by Index Recheck: 0
10. 49.492 82.363 ↑ 1.3 113,386 4 / 4

Parallel Hash (cost=12,446.99..12,446.99 rows=148,299 width=162) (actual time=82.363..82.363 rows=113,386 loops=4)

  • Buckets: 524288 Batches: 1 Memory Usage: 93184kB
11. 32.871 32.871 ↑ 1.3 113,386 4 / 4

Parallel Seq Scan on paths_tbl (cost=0.00..12,446.99 rows=148,299 width=162) (actual time=0.017..32.871 rows=113,386 loops=4)

12. 1.594 3.360 ↑ 1.0 9,403 4 / 4

Hash (cost=145.32..145.32 rows=9,432 width=12) (actual time=3.360..3.360 rows=9,403 loops=4)

  • Buckets: 16384 Batches: 1 Memory Usage: 569kB
13. 1.766 1.766 ↑ 1.0 9,403 4 / 4

Seq Scan on dates_tbl (cost=0.00..145.32 rows=9,432 width=12) (actual time=0.093..1.766 rows=9,403 loops=4)

14. 0.094 0.334 ↓ 1.1 463 4 / 4

Hash (cost=11.05..11.05 rows=405 width=22) (actual time=0.334..0.334 rows=463 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 33kB
15. 0.240 0.240 ↓ 1.1 463 4 / 4

Seq Scan on people_tbl (cost=0.00..11.05 rows=405 width=22) (actual time=0.112..0.240 rows=463 loops=4)